[dbo].[BAEEventGetRegistrant]
SQLServer
>
iMIS1521GA
>
Stored Procedures
> dbo.BAEEventGetRegistrant
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@RegistrantID
varchar(30)
30
@EventCode
varchar(10)
10
SQL Script
create
procedure
[dbo]
.
[BAEEventGetRegistrant]
@RegistrantID
VARCHAR
(
30
),
@EventCode
VARCHAR
(
10
)
as
SELECT
*
FROM
EventRegistrant
WHERE
RegistrantID
=
@RegistrantID
AND
EventCode
=
@EventCode
GO
Uses
[dbo].[EventRegistrant]
dbo